

/****** Object:  StoredProcedure [dbo].[SP_recUserRole_Insert]    Script Date: 05/10/2014 08:29:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Beni Khaeroni (jhung.ben@gmail.com)
-- Create date: 09 Mei 2014 10:20 AM
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[SP_recUserRole_Insert]
	(
	--@UserRoleID						[int],
	@UserID						[int],
	@RoleID						[int],
	@CreatedDate						[datetime],
	@CreatedBy						[varchar](50)
	)
AS INSERT INTO master.recUserRole
	(
	--UserRoleID,
	UserID,
	RoleID,
	CreatedDate,
	CreatedBy
	)
VALUES
	(
	--@UserRoleID,
	@UserID,
	@RoleID,
	@CreatedDate,
	@CreatedBy
	)

GO


